{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["出勤簿"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":11,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"出勤簿","index":0,"n_rows":49,"n_cols":21,"rows_kept":49,"cut":false,"hidden":false,"merged":[[3,13,3,14],[3,11,3,12],[9,4,9,8],[6,13,6,14],[6,11,6,12],[4,13,4,14],[4,11,4,12],[5,11,5,12],[5,13,5,14],[5,5,5,6],[6,5,6,6],[3,5,3,6],[4,5,4,6],[3,1,3,4],[4,1,4,4],[5,1,5,4],[44,13,44,14],[45,13,45,14],[12,13,12,14],[39,13,39,14],[40,13,40,14],[41,13,41,14],[42,13,42,14],[43,13,43,14],[34,13,34,14],[35,13,35,14],[36,13,36,14],[37,13,37,14],[38,13,38,14],[29,13,29,14],[30,13,30,14],[31,13,31,14],[21,13,21,14],[22,13,22,14],[23,13,23,14],[32,13,32,14],[33,13,33,14],[24,13,24,14],[25,13,25,14],[26,13,26,14],[27,13,27,14],[28,13,28,14],[47,1,48,2],[48,3,48,5],[8,1,8,14],[12,1,12,2],[11,1,11,2],[47,3,47,5],[9,2,9,3],[11,10,11,11],[12,10,12,11],[14,13,14,14],[15,13,15,14],[16,13,16,14],[17,13,17,14],[18,13,18,14],[19,13,19,14],[20,13,20,14],[6,1,6,4],[4,9,4,10],[3,9,3,10],[6,9,6,10],[5,9,5,10],[6,7,6,8],[5,7,5,8],[4,7,4,8],[3,7,3,8]]}
[]
[]
[]
[null,"出勤A",null,null,null,"始業時間",null,"終業時間",null,"出勤B",null,"始業時間",null,"終業時間"]
[null,"早1",null,null,null,0.41666666666666669,null,0.75,null,"遅1",null,0.41666666666666669,null,0.83333333333333337]
[null,"出勤C",null,null,null,"始業時間",null,"終業時間",null,"出勤D",null,"始業時間",null,"終業時間"]
[null,"早2",null,null,null,null,null,null,null,"遅2"]
[]
[null,"《出勤簿》"]
[null,null,"[氏名]",null,"鶴谷　朋亮",null,null,null,null,null,null,null,null,null,null,null,"基準の日付","1ヶ月前"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),16)","v":"2017-12-16"},{"$f":"IF(YEAR($Q$11)=12,1,DATE(YEAR($Q$11),MONTH($Q$11)-1,DAY($Q$11)))","v":"2017-11-16"}]
[null,"2017-12-16",null,null,null,null,null,null,null,null,"3ヶ月定期代"]
[null,{"$f":"MONTH(B12)","v":12},null,"～",{"$f":"IF(B13+1>12,1,B13+1)","v":1},null,null,null,null,"交通費","\\12,345",null,"÷3=",{"$f":"ROUND(K13/3,0)","v":4115}]
[]
[null,"日","曜","シフト","掃","出勤","退社","休憩","終了","就業","遅刻","早退","欠勤","備考",null,null,"労働時間","休憩時間","6時間未満、休憩無し","6時間以上、休憩60分","最終判断"]
[{"$f":"B12","v":"2017-12-16"},{"$f":"IF(AND(MONTH(A16)=$B$13+1,DAY(A16)>=16),\"\",A16)","v":"2017-12-16"},{"$f":"IF(B16=\"\",\"\",CHOOSE(WEEKDAY(B16,1),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":"土"},null,null,null,null,null,null,{"$f":"IF(OR(F16=\"\",G16=\"\",D16=\"休\",D16=\"欠\"),\"\",(G16-F16)-(I16-H16))","v":""},null,null,null,null,null,null,{"$f":"IF(OR(D16=\"\",D16=\"休\"),\"\",ROUNDDOWN(G16-F16,7))","v":""},{"$f":"IF(Q16=\"\",\"\",ROUNDDOWN(SUM(I16-H16),7))","v":""},{"$f":"IF(Q16=\"\",\"\",IF(AND(Q16<ROUNDDOWN(TIMEVALUE(\"6:00\"),7),ROUNDDOWN(SUM(I16-H16),7)=0),\"○\",\"次へ\"))","v":""},{"$f":"IF(Q16=\"\",\"\",IF(Q16<ROUNDDOWN(TIMEVALUE(\"6:00\"),7),\"\",IF(Q16>=ROUNDDOWN(TIMEVALUE(\"6:00\"),7),IF(R16>=ROUNDDOWN(TIMEVALUE(\"1:00\"),7),\"○\",\"×\"))))","v":""},{"$f":"IF(Q16=\"\",\"\",IF(OR(S16=\"×\",T16=\"×\"),\"×\",\"○\"))","v":""}]
[{"$f":"A16+1","v":"2017-12-17"},"2017-12-17",{"$f":"IF(B17=\"\",\"\",CHOOSE(WEEKDAY(B17,1),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":"日"},null,null,null,null,null,null,{"$f":"IF(OR(F17=\"\",G17=\"\",D17=\"休\",D17=\"欠\"),\"\",(G17-F17)-(I17-H17))","v":""},null,null,null,null,null,null,"",{"$f":"IF(Q17=\"\",\"\",ROUNDDOWN(SUM(I17-H17),7))","v":""},{"$f":"IF(Q17=\"\",\"\",IF(AND(Q17<ROUNDDOWN(TIMEVALUE(\"6:00\"),7),ROUNDDOWN(SUM(I17-H17),7)=0),\"○\",\"次へ\"))","v":""},{"$f":"IF(Q17=\"\",\"\",IF(Q17<ROUNDDOWN(TIMEVALUE(\"6:00\"),7),\"\",IF(Q17>=ROUNDDOWN(TIMEVALUE(\"6:00\"),7),IF(R17>=ROUNDDOWN(TIMEVALUE(\"1:00\"),7),\"○\",\"×\"))))","v":""},{"$f":"IF(Q17=\"\",\"\",IF(OR(S17=\"×\",T17=\"×\"),\"×\",\"○\"))","v":""}]
[{"$f":"A17+1","v":"2017-12-18"},"2017-12-18","月",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2017-12-19","2017-12-19","火",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2017-12-20","2017-12-20","水",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2017-12-21","2017-12-21","木",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2017-12-22","2017-12-22","金",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2017-12-23","2017-12-23","土",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2017-12-24","2017-12-24","日",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2017-12-25","2017-12-25","月",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2017-12-26","2017-12-26","火",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2017-12-27","2017-12-27","水",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2017-12-28","2017-12-28","木",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2017-12-29","2017-12-29","金",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2017-12-30","2017-12-30","土",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2017-12-31","2017-12-31","日",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2018-01-01","2018-01-01","月",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2018-01-02","2018-01-02","火",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2018-01-03","2018-01-03","水",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2018-01-04","2018-01-04","木",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2018-01-05","2018-01-05","金",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2018-01-06","2018-01-06","土",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2018-01-07","2018-01-07","日",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2018-01-08","2018-01-08","月",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2018-01-09","2018-01-09","火",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2018-01-10","2018-01-10","水",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2018-01-11","2018-01-11","木",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2018-01-12","2018-01-12","金",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2018-01-13","2018-01-13","土",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2018-01-14","2018-01-14","日",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
["2018-01-15","2018-01-15","月",null,null,null,null,null,null,"",null,null,null,null,null,null,"","","","",""]
[]
[null,"合計",null,"出勤\n日数",null,null,"休日\n日数",null,null,"就業","遅刻","早退","欠勤"]
[null,null,null,{"$f":"IF(OR(COUNTA(出勤状況)=0,G49=\"\"),\"\",COUNTA(出勤状況)-G49-COUNTIF(出勤状況,\"欠\")\n)","v":""},null,null,{"$f":"IF(COUNTIF(出勤状況,\"休\")=0,\"\",COUNTIF(出勤状況,\"休\"))","v":""},null,null,{"$f":"IF(SUM(出勤数)=0,\"\",SUM(出勤数))","v":""},{"$f":"IF(COUNT(遅刻数)=0,\"\",SUM(遅刻数))","v":""},{"$f":"IF(COUNT(早退数)=0,\"\",SUM(早退数))","v":""},{"$f":"IF(SUM(欠勤数)=0,\"\",SUM(欠勤数))","v":""}]